package edu.bds

import org.grails.plugins.excelimport.*

class PSPDataExcelImporter extends AbstractExcelImporter {
	
	Map CONFIG_PSPDATA_COLUMN_MAP = null
	
	public PSPDataExcelImporter(fileName){
		super(fileName)
	}
	
	public setConfig(String sheetName){
		CONFIG_PSPDATA_COLUMN_MAP = [
					sheet: sheetName,
					startRow: 3,
					columnMap:  [
						'B':'phaseName',
						'C':'startTime',
						'D':'actualTime',
						'E':'interruptTime'
					]
				]
	}
	
	List<Map> getPSPData() {
		List pspDataList = ExcelImportUtils.convertColumnMapConfigManyRows(workbook, CONFIG_PSPDATA_COLUMN_MAP);
	}
}
